| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I format a cell to always have an ' in it?
I'm trying to set up a spreadsheet for data entry, the entry will always be
numbers but I want the numbers to start with an '. Would like to set it up so that it appears automatic. The ' does not need to show it just needs to be there for uploading purposes. When we type them in by hand they dissapear when we download them and we end up having to put them back in manually. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional cell format based on cell in same row, previous column | Excel Worksheet Functions | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Cell data format | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Threaded Mode
