LinkBack URL
About LinkBacks
Numbers in my spreadsheet are always to 2 decimal places even though I have set the number format to 0. Have I lost a template or something?
Numbers in my spreadsheet are always to 2 decimal places even though I have set the number format to 0. Have I lost a template or something?
Hi,
Take a look at Tool > Options > Edit and uncheck fixed decimal places
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Unable to format number in cells
That's it. Many thanks.
Glad to help - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks