I am trying to format my spreadsheet so zeroes at the beginning and end are not dropped.
Example
001.10
023.00
Can anyone tell me how?
Thank you!
I am trying to format my spreadsheet so zeroes at the beginning and end are not dropped.
Example
001.10
023.00
Can anyone tell me how?
Thank you!
If you want to keep it as text, add the prefix ' (so e.g. '001.10) or use the numberformat "text"
Hi,
Use the custom number format
000.00
Regards,
Aardigspook
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks