I got a problem . This morning my last export gave me this. what is this format or character in cells.
Thanks in advance!
indent... Anyone can give me a tip how to transfer it into spaces?
I got a problem . This morning my last export gave me this. what is this format or character in cells.
Thanks in advance!
indent... Anyone can give me a tip how to transfer it into spaces?
Last edited by dimitrov_dimityr; 10-21-2013 at 06:44 AM.
Hi,
Go into Format Cells/Alignment and you will see that these cells have been formatted as Left (Indent) with an Indent of 7.
Amend as suits your requirements.
Regards
Just Indentation getting applied on those cells.
Select the range>>Right Click>>Format Cells>>Alignment>>Indent>0>Ok..
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
welcome to the forum. are you having any problems with it or are you just curious why? select those cells & right-click -> Format Cells -> Alignment. you'll see that Indent is at 7. you can change it to 0 if you want
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thanks all for the fast response. I was getting instead of indent --- spaces
All my transformations were based on number of the spaces in front of the values.
I will write something to get the indentvalue and insert spaces depending on it.
Thanks all!!! You are great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks