Home |
Search |
Today's Posts |
#1
|
|||
|
|||
True to TRUE
I'm entering data for a database at work and when I type in the last name
"True" Excel is changing it to "TRUE." I try to just undo it and it won't. How do I make it so it's just True???? |
#2
|
|||
|
|||
TRUE is a special value in Excel. To enter True, precede the text
with an apostrophe. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Nikki@CustomMortgageSolutions" ft.com wrote in message ... I'm entering data for a database at work and when I type in the last name "True" Excel is changing it to "TRUE." I try to just undo it and it won't. How do I make it so it's just True???? |
#3
|
|||
|
|||
or set the Cell you're typing in (or row or column) format to text
Excel is seeing true as a boolean value. Chip's solution is equally correct. "Chip Pearson" wrote: TRUE is a special value in Excel. To enter True, precede the text with an apostrophe. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Nikki@CustomMortgageSolutions" ft.com wrote in message ... I'm entering data for a database at work and when I type in the last name "True" Excel is changing it to "TRUE." I try to just undo it and it won't. How do I make it so it's just True???? |
#4
|
|||
|
|||
"Nikki@CustomMortgageSolutions" wrote: I'm entering data for a database at work and when I type in the last name "True" Excel is changing it to "TRUE." I try to just undo it and it won't. How do I make it so it's just True???? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increment a counter in Excel | Excel Worksheet Functions | |||
Adding True False Results | Excel Worksheet Functions | |||
Grand Totals @ Same Place | Excel Worksheet Functions | |||
If Function true value in Red | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |